SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_UpdateLectureClickNumber] ( @JOL_Lecture_No INT )
AS 
    UPDATE  dbo.JOL_Lecture
    SET     JOL_Lecture_ClickNumber = JOL_Lecture_ClickNumber + 1
    WHERE   JOL_Lecture_No = @JOL_Lecture_No
GO
